CREATE OR REPLACE TRIGGER MYTRIG1
  BEFORE INSERT OR DELETE OR UPDATE ON EMP
  FOR EACH ROW
 
  BEGIN 
     IF TO_CHAR(SYSDATE,'DY') = 'SUN' THEN
       DBMS_OUTPUT.PUT_LINE('Today is Holiday ...');
     ELSE     
       DBMS_OUTPUT.PUT_LINE('Welcome back ....');   
     END IF;
  END;
/ 



 